Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
You could use a help sheet, I doubt you want to use round in all 16777216 cells
assume you have values in A1:H500 in Sheet1, insert a new sheet and select A1:H500, with A1 as the active cell type =Sheet1A1 press ctrl + enter, now you can copy and paste special as values over the old values in Sheet1 or paste as values in place and if you want you can delete Sheet1 and rename the help sheet to Sheet1 Regards, Peo Sjoblom "Pedro Serra" wrote: Insert round function for all the cells in an Excel Worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Counting Function Dilemma | Excel Worksheet Functions |