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 |
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 |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com