some of the values i have changed and manually entered , and the thy do turn red
Aug/Sep
you can see the zero 0 are left justified -- usually means text and where i have overwritten and manually entered have turn red
if you put the file on to a share - I can take a futher look
problem here is the XL2BB add -in reformats and shows as Rigth justified !!!!!
Book4 |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB |
---|
1 | QTY SOLD 12 MNTH | Feb. 23 | Jan. 23 | Dec. 22 | Nov. 22 | Oct. 22 | Sept. 22 | Aug. 22 | Jul. 22 | Jun. 22 | May. 22 | Apr. 22 | Mar. 22 | Feb. 22 | Year Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast |
---|
2 | 189355 | 5000 | 20000 | 15000 | 25000 | 17500 | 12500 | 15000 | 15000 | 15000 | 15000 | 9355 | 17500 | 7500 | 210,867 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 | 17484 |
---|
3 | 1500 | 0 | 0 | 0 | 0 | 1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6,292 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 | 237 |
---|
4 | 63000 | 1000 | 6000 | 7000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 10000 | 3000 | 6000 | 0 | 69,018 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 | 5,835 |
---|
5 | 60640 | 0 | 0 | 16740 | 0 | 10000 | 5000 | 0 | 4000 | 4000 | 10000 | 4000 | 4900 | 0 | 75,640 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 |
---|
6 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 600 | 0 | 2,243 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 |
---|
7 | 1252000 | 10000 | 120000 | 120000 | 60000 | 100000 | 60000 | 90000 | 110000 | 120000 | 120000 | 100000 | 70000 | 172000 | 1,205,027 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 | 102,565 |
---|
8 | 240000 | 0 | 0 | 30000 | 30000 | 60000 | 0 | 40000 | 10000 | 10000 | 14000 | 0 | 16000 | 30000 | 168,266 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 | 7,480 |
---|
9 | 1456200 | 800000 | 0 | 200000 | 50100 | 100000 | 0 | 90000 | 20000 | 30000 | 30000 | 60000 | 30000 | 46100 | 471,931 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 | 14,184 |
---|
10 | 460000 | 20000 | 31000 | 30000 | 40000 | 30000 | 30000 | 50000 | 50000 | 30000 | 20000 | 30000 | 49000 | 50000 | 513,270 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 | 41,926 |
---|
11 | 84162 | 1000 | 12000 | 5948 | 8000 | 12000 | 4512 | 2380 | 4000 | 8000 | 4000 | 11000 | 4002 | 7320 | 82,944 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 | 7,073 |
---|
|
---|
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed
www.dropbox.com