Excel displayed format into an actual value

  Craig.m 12:10 25 Oct 10
Locked

I require a Pounds value to be converted into a 12 digit number with leading zeros and the decimal point removed, I managed to display £350.50 as 000000035050, by the format 000000000000 and then muliply the figure by 100.

The problem with the above is that it is to be used to feed another system so it needs to actually have the content of 000000035050, how can I transpose a large list of £s values into this format, I suppose the multiply by 100 is easy enough but how do I then take the resultant number and rather than display it as the 12 digits above make cell content be that, this is so that the system feeding it will recognise it?

  VoG II 12:15 25 Oct 10

In a spare column try like this

=TEXT(A1*100,"000000000000")

  Craig.m 12:35 25 Oct 10

Exactly what I wanted, a lot simpler than I thought, thanks VoG

  Zak 13:42 25 Oct 10

Cell A1 is formatted Accounting with £
Format the cell B1 as Custom format 000000000000
Formula in Cell B1 = A1
All other cells requiring a 12 digit number need to be formatted with Custom format 000000000000 as above.

I take it that "the system feeding" it is in Excel?

  Zak 13:43 25 Oct 10

Late again, I went off to watch the news and did not refresh page!!

  Zak 13:46 25 Oct 10

and wrong!!!

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…