Home |
Search |
Today's Posts |
#1
|
|||
|
|||
turning numbers into other numbers
I have some sheets within a spreadsheet that are grabbing
data from other cells on other sheets. The cells they are getting the numbers from are in the following format {91.52} (in millions)....so that number equals 91,520,000.....how can i get the celll that is grabbing that number (91.52) to show the full number (91,520,000) in the cell that is pulling in that value |
#2
|
|||
|
|||
Dino,
Assuming cell A1 on Sheet1 contains (91.52), then =+Sheet1!A1*1000000 in another sheet will return what you refer to as the "full number". Rob "Dino Thomas" wrote in message ... I have some sheets within a spreadsheet that are grabbing data from other cells on other sheets. The cells they are getting the numbers from are in the following format {91.52} (in millions)....so that number equals 91,520,000.....how can i get the celll that is grabbing that number (91.52) to show the full number (91,520,000) in the cell that is pulling in that value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |